package com.shangqing.system.droughtinformation.mapper;

import com.shangqing.system.droughtinformation.entity.Vegetation;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface VegetationMapper {
    @Select("select * from vegetation")
    List<Vegetation> getAll();
    @Select("select * from vegetation where year=#{year}")
    List<Vegetation> getByYear(int year);
    @Select("select * from vegetation where name=#{name}")
    List<Vegetation> getByName(String name);
    @Select("select * from vegetation where id=#{id}")
    List<Vegetation> getById(int id);
}
